create external table jms_ods.tab_abnormal_network_config
   (id string comment '主键id',
        network_code string comment '网点编码',
        network_name string comment '网点名称',
        application_menu string comment '机构编码',
        is_delete tinyint comment '删除标识(1:未删除;0:删除)',
        create_time TIMESTAMP comment '创建时间',
        create_by_name string comment '创建人',
        create_by_code string comment '创建人编码',
        update_time TIMESTAMP comment '更新时间',
        update_by_name string comment '更新人',
        update_by_code string comment '更新人编码'
   )comment '转邮网点配置表'
   PARTITIONED BY (
  `dt` string COMMENT '时间分区')
ROW FORMAT SERDE
  'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS INPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
OUTPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION
  '/dw/hive/jms_ods.db/external/tab_abnormal_network_config';